Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
Letter
Display
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Lock Text Edit Toggel Lock Text Edit LockTextEdit Guard(0) LockTextEdit Guard(1)
Lock Delete Toggel Lock Delete LockDelete Guard(0) LockDelete Guard(1)
Constraint Properties... `8Edit the model properties of this uniqueness constraint. DB Engineer /CMD=1001
Mandatory on role `QPlace the mandatory role dot against the role instead of against the object type. User.MandatoryOnRole
Show Role Player `'Show the Object Type playing this role. DB Engineer /CMD=1002
Database Model master stores embedded model information.
gffff
@@gffff
tBG;b
&DocTitleLong
&PageDesc
&Date &Time
&PageNo
CTimeStamp
Date of last Validation
=YDVA
2NhE
g;jL
8eHu
SI]2F
TErBH
U3-WA
O{4CO+P5
VxSpF
FkA]
"CHs{p
8UCZ
u^]dp
mmh`q1L
Qqvv>K
Ac5w
CTPy
br]I
MyG5
N:Uu$E
wuXC
Jw>b
hTc8
Sb ,K
^BCd
mf.C
fpU5
O{4CO+P
N:Uu$
Sb ,F
tBG;
CValueConstrai
resulted in
CValueConstraint
Grade
is identified by
identifies
letter
char
CCellMatrix
involves
is involved in
MobileNr
FirstName
CObjTypeM
Activity
CRole
CPredicate
CElemArrayOfCells
CElemCell
Activityname
CConstraintList
CUCIndexConstraint
CRoleArray
CMandatoryConstraint
...for...is booked for...
,each ClassRoom is a Room that is a classroom
ClassRoom
is a
Room
is office of
Employee
took
Course
Coursecode
code
Coursework
Surname
is evaluated by
Project
is given
Rating
Ratingnr
smallint
CMultiSeqConstraint
CRoleArrayArray
is of
ProjectTitle
varchar
is managed by
Projectnr
empNr
is a classroom
is in
Building
Buildingnr
CRoleList
HourSlot
HourSlotcode
name
Microsoft SQL Server (4.2+)
VisioX:Raid4
roomNr
firstName
projectNr
managerEmpNr
projectTitle
evaluatorEmpNr
rating
CMapCodeList
CMapCode
("rating" between 1 and 7)
CLogicalKey
buildingNr
CMappingGroup
CRolePath
CAggregate
CMappingNodeArray
CAggregateInst
CMappingNodeList
CUnambiguousPathList
CUnambiguousPath
RoomBooking
hourSlot
activityName
CForeignKey
isClassroom
CDataType
Is a classroom
surname
mobileNr
courseCode
grade
("grade" in ('A','B','C','F'))bn;M
lidation
Microsoft Visio
about
above
across
after
against
along
around
before
behind
below
beneath
beside
besides
beyond
concerning
contained
contains
could
despite
down
during
except
excepting
identified
identify
inside
into
like
might
near
number
onto
outside
over
regarding
round
shall
string
should
through
throughout
till
toward
under
underneath
until
upon
value
were
will
with
within
would
"ClassRoom HourSlot booked Activity
2. MaDisj_SetComp constraints 2. MaDisj_SetComp constraints
UXwwxU_
WwUU_
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D77.chm!#34338
Database Properties...
`BEnter the sheet id of the shape that you want this text to follow. Shape ID to Track
`xIdentify the 'Tracked' shape's control point by entering it's row number within the controls section of the shape sheet. Control Row to Track
`WSet to TRUE to automatically delete this shape when the shape being tracked is deleted. Auto Tracking Delete
Mandatory constraint
Version
Sheet. !User.SnapTarget
`KSet to allow free-form edits (manual edits are not maintained in the model)
DB Engineer /CMD=1003 PinX PinY User.OldPinX User.OldPinY Shape Tracking Support
Shape Tracking Support
PinX guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y Shape Tracking Support
PinY guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y Shape Tracking Support
`.Specifies the bubble shape's width and height.
User.Snapping Sheet. !User.DBShapeType=112 User.Snapping
Prop.RefSheetID Prop.RefControl User.ClearSnapping PinX PinY
User.ClearSnapping IF(sheet. `!!User.SnapTarget=-999,TRUE,FALSE) User.Snapping
DB Engineer /CMD=1008 `>Notify the add-on after this Mandatory constraint shape moves.
Database Properties... DB Engineer /CMD=1001
Split X/OR constraint User.SnapTarget
`'Set to display this constraint as X/OR.
Adds a predicate to your ORM source model.
ween objects in the database.
Vis_D77.chm!#30217 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
` Indicates the predicate's arity.
`$Specifies the version of this shape.
Predicate Shape
`%Unique identifier used by the add-on.
`]Set to allow user to manually edit this shape (Manual edits are not maintained in the model.)
`Ruse,shape,objects,between,Database,specify,source,ORM,NIAM,Predicate,relationships
`HUse this shape to specify relationships between objects in the database.
DB Engineer /CMD=1009 `OWhen the predicate is flipped on its horizontal axis, refresh the shape's text.
Show Role Players DB Engineer /CMD=1002
Fact Editor... DB Engineer /CMD=2022
Show All Constraints DB Engineer /CMD=1006
Add Constraints... DB Engineer /CMD=2023
ORM constraint support. Added dynamically as a subshape of a Predicate group shape to identify the roles involved in a constraint.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D77.chm!#34340
Role Link
`=Indicates the lowest role position involved in this Role Link
`>Indicates the highest role position involved in this Role Link
`(Calculates the 'height' of the Role Link
Prop.r1 Prop.r2 Prop.r3 Prop.r4 Prop.r5 Prop.r6 Prop.r7 Prop.r8 Prop.r9 `&Clear Prop.r<n> flags where arity < n.
User.TrackingLinkPosition Prop.LinkPosition User.TrackingLinkPosition IF(LocPinY-PNTY(LOC(PNT(Sheet. !LocPinX Sheet. !LocPinY)))>=0 -1*ABS(Prop.LinkPosition) ABS(Prop.LinkPosition))
DB Engineer /CMD=1003
role 1 `*Set if role 1 is involved in the role link
role 2 `*Set if role 2 is involved in the role link
role 3 `*Set if role 3 is involved in the role link
role 4 `*Set if role 4 is involved in the role link
role 5 `*Set if role 5 is involved in the role link
role 6 `*Set if role 6 is involved in the role link
role 7 `*Set if role 7 is involved in the role link
role 8 `*Set if role 8 is involved in the role link
role 9 `*Set if role 9 is involved in the role link
Predicate Arity `.What is the arity of the associated predicate?
Link Position `ePositive number for 'above' predicate positioning, negative number for 'below' predicate positioning.
Collapsible `WSet if it is OK for the role-link to be collasped (hidden) under certain circumstances.
Shape ID to Track `aInitialize with the sheet id of the bubble constraint that this role link will be connected with.
Auto Tracking Delete `WSet to have DB Modeling solution delete this shape if it's referenced shape is deleted.
ORM constraint support. Connects a Bubble constraint to a predicate.
Constraint connector
Shape Version
User.RefConstraint User.RefConstraint =sheet. !PinX
User.RefPredicate User.RefPredicate sheet. !PinX
`$Shape ID of the connected constraint `mSet to the sheet ID of the constraint shape that this constraint connector is/or is going to be connected to.
`#Shape ID of the connected predicate `lSet to the sheet ID of the predicate shape that this constraint connector is/or is going to be connected to.
AutoTrackingDelete Set this to TRUE if you want the shape to notify the DB Modeling Solution, whenever either the referenced constraint or predicate is deleted.
1. UniqueExt constraints 1. UniqueExt constraints
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D77.chm!#34329
Is Primary Uniqueness `1Set if this is the primary uniqueness constraint.
(Primary) uniqueness constraint
`!Set to specify Primary Uniqueness
3. Value constraints 3. Value constraints
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D77.chm!#34342
esc(0)
val
Hide Bubble
Show Tiny Bubble
Constraint Text
Value constraint
Connector Connector
Adds an object type that is a subtype or child of a parent object type to your ORM source model.
the parent.
Vis_D77.chm!#30218 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Subtype Relationship
Shape's Version
`euse,child,shape,type,Database,object,another,specify,source,Relationship,Parent,ORM,NIAM,Subtype,Draw
`lUse this shape to specify an Object Type to be a subtype of another. Draw 'from' the child 'to' the parent.
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D77.chm!#34334
Exclusion constraint
User.Snapping Sheet. !User.DBShapeType=111 User.Snapping
DB Engineer /CMD=1007 `>Notify the add-on after this Exclusion constraint shape moves.
UwwuW
uUuUW
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved. Vis_D77.chm!#34341
Subset constraint
`*True to use subset symbol, False to use S.
Adds an object type to your ORM source model.
in the database.
ffffff
?ffffff
Vis_D77.chm!#30216 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
`7Object type kind (entity = 1, value = 2, external = 3).
Object Type
Specifies the shape's version.
`?Use this shape to specify the kinds of objects in the database.
`Duse,shape,objects,type,Database,object,specify,source,kinds,ORM,NIAM
DB Engineer /MODEL=3 /CMD=99 `/Refresh shape after Prop.ValueListSize changes.
Pffffff Controls.X1 User.TextPinX Controls.Y1 User.TextPinY
`Q(-DTû `Q(-DT
ffffff ffffff
Height User.Height
Width User.Width
Show Relationships DB Engineer /CMD=1002
`3maximum number of items displayed in the value list Value list size
Reposition Object Type's Name
C:\Program Files\Microsoft Office\Visio10\1033\Solutions\Database\ORM Source (US units).vss
`&{65F4BE83-C127-47EB-A59F-656AB6A5A077} `%Unique identifier used by the add-on.
Controls.X1 User.TextPinX Controls.Y1 User.TextPinY User.oldWidth User.oldHeight User.oldAngle
`&{52557C9F-5E5C-44B8-A8F1-87514E8048DF}
Reposition text
Show Role Players
Fact Editor...
Add Constraints...
Show All Constraints
`&{246CB458-E89C-4A19-8B59-B4529CF66B18} `%Unique identifier used by the add-on.
Controls.X1 User.TextPinX Controls.Y1 User.TextPinY
`&{9170D43B-7E35-453F-B8C0-1265107977B6}
Show Role Player
`&{1CBF4BB7-3089-4EA0-96B2-07E7FBD0AAEB}
`&{2DC340CE-5D25-45C0-9CE6-B849ADEE6F5C}
`&{B9D84973-FF30-481F-BFAC-5F0DD11CE623} `%Unique identifier used by the add-on.
`&{2B8E85B0-90A4-44AD-953C-3EF44EC79E6E}
`&{9DDA0534-FE21-42B3-8D02-19B48D4897D0}
`&{68BB1AF3-D572-448F-9159-A65694BFED7C}
`&{C65F957D-BAE7-44EE-80CB-BC45AD250093} `%Unique identifier used by the add-on.
`&{6C37E603-5323-4EFE-8683-E79C84BC2154}
Mandatory on role
`&{5619881F-5378-4670-BE47-F9CC0CA3E3AD}
`&{92FE5439-9436-409F-AA44-42DB93E2C627}
Constraint Properties...
`&{D8457854-8236-4AD9-B0A5-40BF8EB8312A} `%Unique identifier used by the add-on.
`&{E153077E-DDE0-481E-B666-8FAD86DB968E}
`&{25BF446A-83CF-4175-B10D-56006DEF9318}
`&{FE998B0A-75FA-441E-86CD-F2D8DA3E2D14} `%Unique identifier used by the add-on.
`&{66852D72-44A2-4EF0-8454-7DA2D2BBE49C}
E`ej)XãÕ E`ej)X
`&{9260F169-85FF-40EB-93FC-2ECA685A24B8} `%Unique identifier used by the add-on.
`&{9E6A3447-34F7-4E56-9435-AE4E3A557524}
`&{D1D5A6D3-F1C0-4090-8900-43B91C2215D7}
`&{BCB0E026-1E5A-4410-914C-7AB787B6B428}
`&{8300C167-250C-4D55-A42B-E0F8E96B5BA6}
`&{FD44211D-37B2-4BE0-A178-1561CBD32353}
`&{95C3ECE3-8570-414F-8C00-D9882FF472D5}
`&{540F72FD-7245-4842-AB87-033F98075DA6}
`&{4EFA65A4-13B5-4FAC-8461-3B1A9B6D55ED}
`&{EE2949E6-FC22-4348-81E3-211F8DAED695} `%Unique identifier used by the add-on.
5EMQ Reposition text
`&{171F5F87-CAFD-49A1-BD9D-AA879165A2DB}
`&{4000AB00-E07B-4B46-8890-5F48EF0BC215}
`&{7C51E222-8771-406E-9E15-A6A5C90976B6}
`&{2FF6D62A-E62A-498F-AEB7-36BB3A0B3145}
`&{B0E1E160-F9FA-49B7-AEFF-CB8295F4138D}
Show Relationships
`&{374957CB-2002-415B-8B2A-16A81FBE4450}
`&{082D4BE0-E698-4A36-AEBC-38242EA59DF4}
Pffffff
`&{BF11B9DF-B7D9-4DAF-A056-E18952CD6015}
@UUUUUU
?@UUUUUUå Ó?@UUUUUU
`%Unique identifier used by the add-on. `&{C5AC3255-4C1D-41C0-862C-9FF1147E1DFC}
`&{9AF683D2-8A65-468F-BFEA-478DE150C728}
?@UUUUUUå Ë?@UUUUUU
Reposition Value constraint
`&{167DEA0E-16ED-4FD3-9A60-E80E40E6D724}
`&{65F4BE83-C127-47EB-A59F-656AB6A5A077}
`&{D5FBE0DB-99E7-4DE3-9903-780395AA28C1}
?@UUUUUUå Î?@UUUUUU
`&{756FBB56-90E5-4B7B-BEBB-163BC446999F}
`&{20A06CB8-3E10-4C61-BD3E-D1954860602B}
?@UUUUUUå?@íSÂŽã4Ð?@UUUUUU
@
Background-1
`&{B37ECC29-1A81-4617-BC29-15479B4ED3CB} `%Unique identifier used by the add-on.
`&{C8A6DC0E-4C1A-4C24-8E1F-2176161F5C38}
`&{C3BE8A08-6E28-473E-A92C-589D6C71DD46}
`&{9B6514F9-7827-4D32-AD39-B28D0BFA0964} `%Unique identifier used by the add-on.
` QUUUUU Reposition text
`&{8F6150FF-5C40-479D-B614-EDFC718E7AEE}
`&{E210ABA1-7386-4AE9-8B98-EC940A0CF6AC}
`&{CA20B08B-B4A2-423A-8413-CDEF166190AF} `%Unique identifier used by the add-on.
`&{B037D004-9627-4419-B7F6-B22448259C9D}
`&{E3EF5525-BF3B-466B-AB4C-9FF15F56B1DB}
`&{BF0F1FB1-E5C9-4EED-AEA4-340CC00DB08C} `%Unique identifier used by the add-on.
`&{D2D61051-5ADA-4B6F-BC69-650EE004AF64}
`&{0273AB1D-8850-4DCC-BDC8-CB39CE58177F}
`&{DEA91AE8-CE12-45E7-82B0-CE4307B23E02}
aX)g
`&{3EEFEB22-EEDC-46E0-A650-3036CF8B274C}
`&{38135724-6571-4EC9-844A-43EEEA95E4D1}
`&{24B60AB0-E9B8-4025-B55F-A59C3AF938D5}
`&{C5C6369D-5BF0-4964-B9B9-A419210EFA63}
`&{58C65A36-D4A6-4C05-896E-B5D74BB5C0EB}
`%Unique identifier used by the add-on. `&{BF3F6CF0-41B8-470D-B570-9E6088F15CAE}
`&{F9B2E67B-B126-4997-B220-1EC3CBB06963}
?@UUUUUUå?@i‹½«ªªË?@UUUUUU
`&{717E2E77-D4F0-45F0-9DD5-64186E2CF522}
?@UUUUUUå Í?@UUUUUU
`&{0E416DF2-C3F5-40C5-812D-0ADF138137F7}
`&{26BAA80B-35E9-4C25-9865-0FB47797FE2B} `%Unique identifier used by the add-on.
`&{DAE81EE8-0052-4833-A884-3678C54654AC}
`&{68937BFD-0371-4947-8183-4C01AE88634B}
`&{13AB6973-5D01-49F0-B7CB-A4C315FF1E38} `%Unique identifier used by the add-on.
` qUUUUU Reposition text
`&{E6F28C61-065A-4FF8-A05C-45CA299F33A9}
`&{06F4C7EA-E68B-4C6C-BB89-CB2DF0649275} `%Unique identifier used by the add-on.
` qfffff Reposition text
`&{C08CBA8E-DA3E-4E91-BB9C-83C9C1040FCE}
`&{79505443-60E2-4222-A924-8166835CA62D}
`&{61C21820-AF0E-4815-A1BF-F461CD77ADEC}
`&{1F8E4549-91C1-494A-ADCE-5BD4E337E4AD} `%Unique identifier used by the add-on.
`&{8552D6AB-EC3E-4538-B594-EEC0A721B38D}
`&{3853DEB1-6F09-4591-9006-93EA3E0FC730}
`&{EEFDADB4-666D-432E-9587-88567FD6C6D8}
`&{5F064ABB-2E54-438E-9422-4348737B707F}
`&{45419E60-FB81-412E-B6D6-B1F46F7B3DEC}
`&{B850EB4B-8289-4B27-8602-6A717A91618A} `%Unique identifier used by the add-on.
`&{BD8684CF-29B0-4229-AD97-A3AEA6D1961E}
`&{2B0C880A-7758-4C0D-883A-724EEEFDDE56}
`&{0A65B52B-1CFE-43DF-BB11-0916971D14A1}
`&{9404A86C-F7BE-482D-B54D-07738F4674A4}
`&{9FCC532B-5742-4397-83C6-C47DD8C7262B}
`&{073BFFEF-6C62-4993-9349-C102FA094DF7}
`&{5D3D419E-1898-41C1-B7FD-D9C59D71846D}
`&{7838F280-29DE-45E5-9268-C066A5B9BEA0}
`&{79585ABD-1DF4-42B8-AE2F-7C60889700A1}
`&{71FA884E-CA7C-4291-8B7D-615C3A37E02D}
?@UUUUUUå?@i‹½«ª¢Í?@UUUUUU
`&{70114FA1-8D43-4E55-9728-D56868F436A4}
?@UUUUUUå?@˜þl9ŽcÑ?@UUUUUU
DB Engineer
/CMD=1 /MODEL=3
Guide
TheDoc
Gesture Format
Connector
White line
Arial centered
Arial top left
Arial top
Times centered
Times top
Times top left
Watermark Title
Internal Uniqueness
DBShapeType
RefShapeGuid
DBShapeVersion
ManualEdits
IsPrimary
Role
RolePosition
BestX
BestY
PredicateArity
IsMandatory
MandatoryOnRole
Database Model
Visio Extended Data
OTKind
visDescription
visKeywords
visVersion
TriggerRefresh
ObjectifiedFact
NestedArity
NestsPredicate
NestedRoleWidth
NestedRoleHeight
RelocateText
TextPinX
TextPinY
Height
ResetHeight
NestedPredicateRefGuid
Width
ResetWidth
ValueListSize
Predicate
Arity
NestingOTRefGuid
RefSheetID
RefControl
AutoTrackingDelete
SnapTarget
SetSnapTarget
DBEventTrigger
OldPinX
OldPinY
SetPinX
SetPinY
BubbleSize
Snapping
SetSnapping
ClearSnapping
OnClearSnapping
SetClearSnapping
ShapeMovedNotification
SetReferencedConstraintShape
SetReferencedPredicateShape
RefConstraint
RefPredicate
PredElementID
RefConstraintSheetID
RefPredicateSheetID
Role link
LowRoleBound
UpperRoleBound
RoleWidth
RoleHeight
RoleLinkHeight
ClearSettings
NoShowRoleLink
TrackingLinkPosition
SetTrackingLinkPosition
LinkPosition
Collapsible
UseSymbol
Constraint_141_1
Object Type.17
(Primary) Uniqueness constraint
IsPrimaryUniqueness
Constraint_148_2
Constraint_137_2
oldWidth
ValueConstraintRefGuid
HideBubble
ShowTinyBubble
ConstraintText
oldHeight
Constraint_137_1
Constraint_144_2
Constraint_144_1
oldAngle
Constraint_620_2
Constraint_620_1